<?php include('includes/before_html.php'); ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">

    <head>

        <meta http-equiv="content-type" content="text/html; charset=utf-8" />

        <meta name="description" content="" />

        <meta name="keywords" content="" />

        <meta name="author" content="" />

        <?php include('includes/head.php'); ?>

        <title><?php echo $heading ?></title>

    </head>

    <body>

        <div id="wrapper">

            <?php include('includes/header.php'); ?>

            <?php include('includes/nav.php'); ?>

            <div id="content">
                <?php
                $db = mysql_connect(db_server, $db_user, $db_password);
                mysql_select_db($db_dbname);

                if ($_GET['t'] == 'privacy') {
                    $result = mysql_query("describe Security");
                    $colnames = '';
                    $values = '';
                    $update = '';
                    while ($row = mysql_fetch_array($result)) {
                        if ($row['Field'] != 'RUID') {
                            $colnames.=$row['Field'] . ",";
                            if ($_POST[$row['Field']] == '1')
                                $val = 1;
                            else
                                $val = 0;
                            $values.= $val . ",";
                            $update.=$row['Field'] . "=" . $val . ",";
                        }
                    }
                    $colnames.="RUID";
                    $values.=$myRuid;
                    $update = substr($update, 0, strlen($update) - 1);
                    $sql = "INSERT INTO Security ($colnames) VALUES ($values) ON DUPLICATE KEY UPDATE $update";
                    echo "SQL QUERY: " . $sql . "<BR><BR>";
                    if ($result = mysql_query($sql))
                        echo "Settings saved.";
                    else
                        echo "Error saving settings.";
                }
               
                ?>

            </div> <!-- end #content -->

            <?php include('includes/sidebar.php'); ?>

            <?php include('includes/footer.php'); ?>

        </div> <!-- End #wrapper -->

    </body>

</html>